SUMROUND3D
Rounds all numbers in a specified range in all worksheets in a workbook to a specified number of digits, then adds them up to return a total. SUMROUND3D is very similar to the SUMROUND function of Edwin's Power Tools (EPT).
The main difference is that SUMROUND3D considers all worksheets, while the SUMROUND function doesn't.
Syntax
SUMROUND3D(range_input, decimal_places)
range_input - is the range for which you want to determine the total value or sum. The same range in all worksheet in the workbook will be considered.
decimal_places - specifies the number of digits to which you want to round numbers.
Remark
[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]